package com.attendance.www.hr.dao.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.attendance.www.hr.beans.SalaryBean;

public interface SalaryExtMapper {
    /**
     * 查询工资报表
     * @param salaryBean
     * @return
     */
    List<SalaryBean> getSalaryList(@Param("salaryBean")SalaryBean salaryBean);
    
    int count(@Param("salaryBean")SalaryBean salaryBean);
    
    /**
     * 查询提交历史
     * @param employeeNo
     * @return
     */
    List<SalaryBean> getSalaryHistory(@Param("employeeNo")String employeeNo);
    
    /**
     * 查询工资表对应提交历史的年月 desc
     * @param employeeNo
     * @return
     */
    List<SalaryBean> getSalaryYearMonth(@Param("salaryBean")SalaryBean salaryBean);
    
    /**
     * 审批人根据申请ID下载报表
     * @param salaryRequestId
     * @return
     */
    List<SalaryBean> getSalaryListById(@Param("salaryRequestId")Integer salaryRequestId);

    /**
     * 查询工资汇总表
     * @param salaryBean
     * @return
     */
    List<SalaryBean> getSalaryTotalList(@Param("salaryBean")SalaryBean salaryBean);
    
    int countTotal(@Param("salaryBean")SalaryBean salaryBean);
}